Fritz: All Fritz/All Fritz.zip/All Fritz/FILES/SPREEETS/EZS.LZH/INCOME.EZS

Text File | 1988-06-03 | 7KB | 677 lines

HDR
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
DAT
3,1,2R
XXXX INTERNATIONAL
1,2,2R
              PROFORMA PROFIT & LOSS (CUM)/(TOTAL)
2,3,2R
INCOME PROJECTONS   $US DOLLARS M(THOUSAND)
2,4,2R
     APRIL 1, 1986 TO MARCH 31, 1987
4,6,2R
   '4>7/86
5,6,2R
  '8>11/86
6,6,2R
 '12/>3/87
8,6,2R
    '04/86
9,6,2R
    '05/86
10,6,2R
    '06/86
11,6,2R
    '07/86
12,6,2R
    '08/86
13,6,2R
    '09/86
14,6,2R
    '10/86
15,6,2R
    '11/86
16,6,2R
    '12/86
17,6,2R
    '01/87
18,6,2R
    '02/87
19,6,2R
    '03/87
1,8,2R
SALES
4,8,2R
(G8:J8)
5,8,2R
(L8:O8)
6,8,2R
(P8:S8)
8,8,2R
4500
9,8,2R
0000
10,8,2R
0000
11,8,2R
0000
12,8,2R
4500
13,8,2R
0000
14,8,2R
0000
15,8,2R
0000
16,8,2R
0000
17,8,2R
0000
18,8,2R
0000
19,8,2R
0000
1,9,2R
 COST OF GOODS SOLD
4,9,2R
(H9:K9)
5,9,2R
(L9:O9)
6,9,2R
(P9:S9)
1,10,2R
 COMMISSIONS
4,10,2R
(H10:K10)
5,10,2R
(L10:O10)
6,10,2R
(P10:S10)
8,10,2R
(H8*.15)
9,10,2R
(I8*.15)
10,10,2R
(J8*.15)
11,10,2R
(K8*.15)
12,10,2R
(L8*.15)
13,10,2R
(M8*.15)
14,10,2R
(N8*.15)
15,10,2R
(O8*.15)
16,10,2R
(P8*.15)
17,10,2R
(Q8*.15)
18,10,2R
(R8*.15)
19,10,2R
(S8*.15)
1,12,2R
TOTAL COST OF GOODS SOLD
4,12,2R
(H12:K12)
5,12,2R
(L12:O12)
6,12,2R
(P12:S12)
8,12,2R
000
9,12,2R
000
10,12,2R
000
11,12,2R
000
12,12,2R
000
13,12,2R
000
14,12,2R
000
15,12,2R
000
16,12,2R
000
17,12,2R
000
18,12,2R
000
19,12,2R
000
1,14,2R
 GROSS MARGIN
4,14,2R
(H14:K14)
5,14,2R
(L14:O14)
6,14,2R
(P14:S14)
8,14,2R
(H8-H12)
9,14,2R
(I8-I12)
10,14,2R
(J8-J12)
11,14,2R
(K8-K12)
12,14,2R
(L8-L12)
13,14,2R
(M8-M12)
14,14,2R
(N8-N12)
15,14,2R
(O8-O12)
16,14,2R
(P8-P12)
17,14,2R
(Q8-Q12)
18,14,2R
(R8-R12)
19,14,2R
(S8-S12)
1,16,2R
TOTAL OPERATING EXPENSES
4,16,2R
(H16:K16)
5,16,2R
(L16:O16)
6,16,2R
(P16:S16)
8,16,2R
(H17:H21)
9,16,2R
(I17:I21)
10,16,2R
(J17:J21)
11,16,2R
(K17:K21)
12,16,2R
(L17:L21)
13,16,2R
(M17:M21)
14,16,2R
(N17:N21)
15,16,2R
(O17:O21)
16,16,2R
(P17:P21)
17,16,2R
(Q17:Q21)
18,16,2R
(R17:R21)
19,16,2R
(S17:S21)
1,17,2R
 OPERATING EXPENSES
4,17,2R
(H17:K17)
5,17,2R
(L17:O17)
6,17,2R
(P17:S17)
8,17,2R
0
9,17,2R
0
10,17,2R
0
11,17,2R
0
12,17,2R
0
13,17,2R
0
14,17,2R
0
15,17,2R
0
16,17,2R
0
17,17,2R
0
18,17,2R
0
19,17,2R
0
1,18,2R
  ADMINISTRATION
4,18,2R
(H18:K18)
5,18,2R
(L18:O18)
6,18,2R
(P18:S18)
1,19,2R
 ADVERTISING & PROMOTION
4,19,2R
(H19:K19)
5,19,2R
(L19:O19)
6,19,2R
(P19:S19)
8,19,2R
0
9,19,2R
0
10,19,2R
0
11,19,2R
0
12,19,2R
0
13,19,2R
0
14,19,2R
0
15,19,2R
0
16,19,2R
0
17,19,2R
0
18,19,2R
0
19,19,2R
0
1,20,2R
 TRAVEL
4,20,2R
(H20:K20)
5,20,2R
(L20:O20)
6,20,2R
(P20:S20)
8,20,2R
00
9,20,2R
00
10,20,2R
00
11,20,2R
00
12,20,2R
00
13,20,2R
00
14,20,2R
00
15,20,2R
00
16,20,2R
00
17,20,2R
00
18,20,2R
00
19,20,2R
00
1,21,2R
 CONTRACT SERVICES
4,21,2R
(H21:K21)
5,21,2R
(L21:O21)
6,21,2R
(P21:S21)
8,21,2R
00
9,21,2R
00
10,21,2R
00
11,21,2R
00
12,21,2R
00
13,21,2R
00
14,21,2R
00
15,21,2R
00
16,21,2R
00
17,21,2R
00
18,21,2R
00
19,21,2R
00
3,25,2R
XXXX INTERNATIONAL
1,26,2R
              PROFORMA PROFIT & LOSS (CUM)/(TOTAL)
2,27,2R
INCOME PROJECTONS   $US DOLLARS M(THOUSAND)
2,28,2R
     APRIL 1, 1986 TO MARCH 31, 1987
4,32,2R
   '4>7/86
5,32,2R
  '8>11/86
6,32,2R
 '12/>3/87
1,34,2R
SALES
4,34,2R
68
5,34,2R
306
6,34,2R
680
1,35,2R
 COST OF GOODS SOLD
4,35,2R
(D38-D36)
5,35,2R
(E38-E36)
6,35,2R
(F38-F36)
1,36,2R
 COMMISSIONS
4,36,2R
(.15*D34)
5,36,2R
(.15*E34)
6,36,2R
(.15*F34)
1,38,2R
TOTAL COST OF GOODS SOLD
4,38,2R
57.6
5,38,2R
259.2
6,38,2R
576
1,40,2R
 GROSS MARGIN
4,40,2R
(D34-D38)
5,40,2R
(E34-E38)
6,40,2R
(F34-F38)
1,42,2R
TOTAL OPERATING EXPENSES
4,42,2R
(D44:D48)
5,42,2R
(E44:E48)
6,42,2R
(F44:F48)
1,44,2R
 OPERATING EXPENSES
1,45,2R
  ADMINISTRATION
4,45,2R
8
5,45,2R
16
6,45,2R
24
1,46,2R
  ADVERTISING & PROMOTION
4,46,2R
10
5,46,2R
20
6,46,2R
30
1,47,2R
  TRAVEL
4,47,2R
8
5,47,2R
16
6,47,2R
24
1,48,2R
  CONTRACT SERVICES
4,48,2R
24
5,48,2R
48
6,48,2R
72
1,50,2R
TOTAL P/L
4,50,2G
(D40-D42)
5,50,2G
(E40-E42)
6,50,2G
(F40-F42)
3,53,2R
XXXX INTERNATIONAL
1,54,2R
              PROFORMA PROFIT & LOSS (CUM)/(TOTAL)
2,55,2R
INCOME PROJECTONS   $US DOLLARS M(THOUSAND)
2,56,2R
     APRIL 1, 1987 TO MARCH 31, 1988
4,60,2R
   '4>7/87
5,60,2R
  '8>11/87
6,60,2R
 '12/>3/88
1,62,2R
SALES
4,62,2R
426.7
5,62,2R
853.4
6,62,2R
1280
1,63,2R
 COST OF GOODS SOLD
4,63,2R
(D66-D64)
5,63,2R
(E66-E64)
6,63,2R
(F66-F64)
1,64,2R
 COMMISSIONS
4,64,2R
(.15*D62)
5,64,2R
(.15*E62)
6,64,2R
(.15*F62)
1,66,2R
TOTAL COST OF GOODS SOLD
4,66,2R
358.4
5,66,2R
716.8
6,66,2R
1072
1,68,2R
 GROSS MARGIN
4,68,2R
(D62-D66)
5,68,2R
(E62-E66)
6,68,2R
(F62-F66)
1,70,2R
TOTAL OPERATING EXPENSES
4,70,2R
(D72:D76)
5,70,2R
(E72:E76)
6,70,2R
(F72:F76)
1,72,2R
 OPERATING EXPENSES
1,73,2R
  ADMINISTRATION
4,73,2R
24.3
5,73,2R
48.7
6,73,2R
73
1,74,2R
  ADVERTISING & PROMOTION
4,74,2R
15
5,74,2R
20
6,74,2R
30
1,75,2R
  TRAVEL
4,75,2R
10
5,75,2R
30
6,75,2R
45
1,76,2R
  DEBT SERVICE
4,76,2R
7
5,76,2R
9.3
6,76,2R
14
1,78,2R
TOTAL P/L
4,78,2G
(D68-D70)
5,78,2G
(E68-E70)
6,78,2G
(F68-F70)
3,81,2R
XXXX INTERNATIONAL
1,82,2R
              PROFORMA PROFIT & LOSS (CUM)/(TOTAL)
2,83,2R
INCOME PROJECTONS   $US DOLLARS M(THOUSAND)
2,84,2R
     APRIL 1, 1986 TO MARCH 31, 1987
4,86,2R
   '4>7/86
5,86,2R
  '8>11/86
6,86,2R
 '12/>3/87
1,88,2R
SALES
4,88,2R
68
5,88,2R
306
6,88,2R
680
1,89,2R
 COST OF GOODS SOLD
4,89,2R
(D92-D90)
5,89,2R
(E92-E90)
6,89,2R
(F92-F90)
1,90,2R
 COMMISSIONS
4,90,2R
(.15*D88)
5,90,2R
(.15*E88)
6,90,2R
(.15*F88)
1,92,2R
TOTAL COST OF GOODS SOLD
4,92,2R
57.6
5,92,2R
259.2
6,92,2R
576
1,94,2R
 GROSS MARGIN
4,94,2R
(D88-D92)
5,94,2R
(E88-E92)
6,94,2R
(F88-F92)
1,96,2R
TOTAL OPERATING EXPENSES
4,96,2R
(D98:D102)
5,96,2R
(E98:E102)
6,96,2R
(F98:F102)
1,98,2R
 OPERATING EXPENSES
1,99,2R
  ADMINISTRATION
4,99,2R
8
5,99,2R
16
6,99,2R
24
1,100,2R
  ADVERTISING & PROMOTION
4,100,2R
10
5,100,2R
20
6,100,2R
30
1,101,2R
  TRAVEL
4,101,2R
8
5,101,2R
16
6,101,2R
24
1,102,2R
  CONTRACT SERVICES
4,102,2R
24
5,102,2R
48
6,102,2R
72
1,104,2R
TOTAL P/L
4,104,2G
(D94-D96)
5,104,2G
(E94-E96)
6,104,2G
(F94-F96)
END